package com.saas.sql;

public class CompanyListQuery
{
  public static String company_list_INSERT_COMPANY_LIST = "insert into company_list (cust_id,cust_name,type,exhibition_period,level_logo,cust_supply,cust_buying,oper_user,oper_time,juristic,enterprise_type_code,eparchy_code,group_contact_phone,fax_nbr,website,post_code,company_address,bank_deposit,bank_account,banking_account,certification,company_scope,email,for_cust_id,update_user_id,update_date,user_count,pspt_id,register_attach,abbreviated,add_date) values(:VCUST_ID,:VCUST_NAME,:VTYPE,:VEXHIBITION_PERIOD,:VLOGO_IMG,:VCUST_SUPPLY,:VCUST_BUYING,:VUSER_ID,now(),:VJURISTIC,:VENTERPRISE_TYPE_CODE,:VEPARCHY_CODE,:VGROUP_CONTACT_PHONE,:VFAX_NBR,:VWEBSITE,:VPOST_CODE,:VCOMPANY_ADDRESS,:VBANK_DEPOSIT,:VBANK_ACCOUNT,:VBANKING_ACCOUNT,:VCERTIFICATION,:VCOMPANY_SCOPE,:VEMAIL,:VFOR_CUST_ID,:VUPDATE_USER_ID,now(),:VUSER_COUNT,:VPSPT_ID,:VREGISTER_ATTACH,:VABBREVIATED,now())";
  public static String company_list_SEL_COMPANY_LIST_ALL = "select * from company_list where cust_name like :VCUST_NAME order by update_date desc";
  public static String company_list_SEL_COMPANY_LIST_DATE_ALL = "select * from company_list where cust_name like :VCUST_NAME and  substring(update_date,1,10) >= :VSTART_DATE and substring(update_date,1,10) <= :VEND_DATE  order by update_date desc";
  public static String company_list_SEL_COMPANY_INFO_BY_CUST_ID = "select c.exhibition_period,c.level_id,c.level_name,c.commend,c.email, c.cust_name, c.dis_state, c.juristic, c.abbreviated, c.enterprise_type_code, c.eparchy_code, c.group_contact_phone, c.fax_nbr, c.company_address, c.post_code, c.pspt_id, c.website, c.bank_deposit, c.bank_account, c.banking_account, c.cust_rage, c.user_count, c.certification, c.company_scope, c.cust_supply, c.cust_buying, c.register_attach, c.back_reason, c.info_auth, c.auto_state, c.oper_time, c.auth_date, c.cust_state,c.level_logo as logo_img,abbreviated from company_list c where c.cust_id=:VCUST_ID ";
  public static String company_list_MOIDFY_COMPANY_LIST = "update company_list set cust_name=:VCUST_NAME,type=:VTYPE,exhibition_period=:VEXHIBITION_PERIOD,level_logo=:VLOGO_IMG,cust_supply=:VCUST_SUPPLY,juristic=:VJURISTIC,enterprise_type_code=:VENTERPRISE_TYPE_CODE,eparchy_code=:VEPARCHY_CODE,fax_nbr=:VFAX_NBR,website=:VWEBSITE,post_code=:VPOST_CODE,company_address=:VCOMPANY_ADDRESS,bank_deposit=:VBANK_DEPOSIT,bank_account=:VBANK_ACCOUNT,banking_account=:VBANKING_ACCOUNT,certification=:VCERTIFICATION,company_scope=:VCOMPANY_SCOPE,email=:VEMAIL,user_count=:VUSER_COUNT,pspt_id=:VPSPT_ID,register_attach=:VREGISTER_ATTACH,abbreviated=:VABBREVIATED,cust_buying=:VCUST_BUYING,group_contact_phone=:VGROUP_CONTACT_PHONE,update_date=now() where cust_id=:VCUST_ID";
  public static String company_list_SEL_COMPANY_LIST_CHONICE = "select * from company_list where cust_name like :VCUST_NAME order by add_date desc,cust_id desc";
}

